Carson Penticuff
Carson Penticuff
Reactions
-
Re: CountIfs results 0
You are correct in that the rollover to 2025 is causing your issue. The formula, as it stands, is looking for dates within the current year, then subtracting one month from today. Since today is mont…1 · -
Re: Is there a CONTAINS alternative for Contact formatted cells?
Yes, you are looking for the HAS() function. =COUNTIFS({P & A - Assignments List | Assigned To}, HAS(@cell, [Name]@row))1 · -
Re: Need a column to auto populate the month NAME when the date column next to it is selected.
If you are looking for the numeric month… short and sweet: =IF(ISDATE([Final Completion Date]@row), MONTH([Final Completion Date]@row), "") If you want the month to appear as text, not quit…1 · -
Re: Sum amounts within certain year and type
You will need to tweak your column names, but this is the general idea: =SUMIFS(amount:amount, type:type, "paint", date:date, YEAR(@cell) = 2023)1 · -
Re: How do I pull the second name from a multiple-contact column?
I think I finally have it: =IFERROR(IF(COUNTM([Project Support]@row) = 2, RIGHT([Project Support]@row, LEN([Project Support]@row) - FIND(",", [Project Support]@row)), IF(COUNTM([Project Sup…1 ·
